Skip to main content

Batch Utilization Report

note

The Batch Utilization Report traces a batch in both directions. It shows the inward / inspection records each batch was created from, and how the batch quantity has been used afterwards (released to production, in process, finished, rejected, and the job work, DC, final inspection and invoice documents it moved on). A batch created from several inspection records lists every one of them.

1. Search the Batch Utilization Report​

Step 1: Reach the Batch Utilization Report​

From the main side menu, click on Production & Quality β†’ Reports β†’ Batch Utilization Report. This will open the Batch Utilization Report search page.

Step 2: Fill in Details​

  • Part [Mandatory][Dropdown] Select the part whose batches you want to trace.
  • Batch Date From [Mandatory][Date] Start of the batch date range. It defaults to the first day of the current month.
  • Batch Date To [Mandatory][Date] End of the batch date range. It defaults to today.
  • Search Button β†’ Lists every batch of the selected part created within the date range.
  • Clear Button β†’ Clears the part and the results, and resets the dates.

Step 3: See the Results​

Click Search. The summary and the batch table appear below the search section.

note
  • If no batch was created for the part in the period, the message No batch was created for this part in the selected period is shown.
  • One search shows up to 300 batches. When the period holds more, a message asks you to narrow the date range.

2. Summary​

The strip above the table totals all the batches listed.

FieldDescription
Batches CreatedNumber of batches created for the part in the period.
Total Batch QtyTotal quantity of those batches.
Released to ProductionBatch quantity for which production serials have been created.
In ProcessReleased quantity that is neither finished nor rejected yet.
FinishedQuantity approved at the last process of the control plan.
RejectedQuantity rejected at any process.
Not Yet ReleasedBatch quantity not yet released to production.
CompletionFinished quantity as a percentage of the total batch quantity.

3. Batch Creation and Utilization Table​

The table has one row for each inward / inspection record used in a batch. The batch columns and the utilization columns span all the rows of that batch, so a batch created from three inspections shows three inward rows against one batch.

Inward / Inspection​

Column NameDescription
S.NoSerial number of the batch.
SourceWhere the material came from: Purchase Inward, Customer Job Work In, Internal Material Inward, Miscellaneous Inward, Returnable DC In or Finished Goods Stock.
Inward No / DateNumber and date of the inward document (for example the GRN).
Supplier / CustomerSupplier, customer or source plant of the inward document.
Inward QtyQuantity received on the inward line.
Inspection NoInspection in which the material was accepted.
AcceptedQuantity accepted in that inspection.
Used in BatchQuantity of that inspection used to create this batch.

Batch​

Column NameDescription
Batch No / DateBatch number and batch date. Click the batch number to open the batch details.
Batch QtyQuantity of the batch.

Batch Utilization​

Column NameDescription
ReleasedBatch quantity released to production.
In ProcessReleased quantity still moving through the processes.
FinishedQuantity approved at the last process.
RejectedQuantity rejected at any process.
Not ReleasedBatch quantity not yet released to production.
CompletionFinished quantity as a percentage of the batch quantity, with the batch status (Not Started, In Progress or Completed).

The last row shows the totals of Used in Batch, Batch Qty and the utilization columns.

Adjusted inspections​

When the accepted quantity of an inspection was adjusted in stock, an Adjusted mark is shown beside its Inspection No. Move the mouse over the mark to read the adjustment remarks. A line under the table explains the mark whenever the result contains an adjusted inspection.

note
  • A batch created from Finished Goods Stock has no inward document, so its inward and inspection columns show -.
  • A batch with no recorded material source shows Not recorded in the Source column.

4. Batch Details​

Click a Batch No in the table to open its details below the table. Click Close to hide them.

The header shows the Batch No with its status, Batch Date, Batch Qty, Material Sources, Released to Production, In Process, Finished, Rejected and Completion, followed by the Part, Control Plan, Production period, Reference and Created By.

4.1 Batch Creation​

The inward / inspection records the batch material was taken from.

Column NameDescription
MaterialMaterial consumed by the batch and the quantity required.
SourceType of inward document.
Inward No / Inward DateInward document number and date.
Supplier / CustomerParty of the inward document.
Order NoPurchase order or material order of the inward.
Party Invoice / DC NoSupplier invoice number, or the DC number when there is no invoice.
Inward QtyQuantity received.
Inspection No / Inspection DateInspection number and date.
Accepted Qty / Rejected QtyQuantities accepted and rejected in the inspection.
Used in BatchQuantity of the inspection used in this batch.
Balance in InspectionAccepted quantity of the inspection still unused.

The last row, Total used in batch, adds up the Used in Batch quantities of all the sources.

4.2 Batch Utilization - Process Wise​

How far the batch quantity has moved through its control plan, one row per process.

Column NameDescription
Process No / ProcessProcess number and name from the control plan.
QuantityQuantity that has reached the process.
ApprovedQuantity approved at the process.
RejectedQuantity rejected at the process.
ReworkQuantity sent for rework.
On HoldQuantity on hold.
PendingQuantity waiting to be processed.
OutsourcedQuantity processed through outsourcing.
Start Date / End DateFirst and last date of work on the process.
No of DaysDays between the start and end date.
ProgressApproved (green) and rejected (red) quantity as a share of the batch quantity.
StatusNot Started, In Progress or Completed.

4.3 Batch Utilization - Transactions​

The documents the batch quantity was moved on after creation: Job Work DC Out, Job Work DC In, Returnable DC Out, Returnable DC In, Non-Returnable DC, Final Inspection and Sales Invoice.

  • The tiles above the table show the quantity and number of documents for each transaction type. Click a tile to show only that type; click it again to show all.
Column NameDescription
TransactionType of document.
Document No / Document DateNumber and date of the document.
PartySupplier or customer of the document.
ProcessProcess the quantity was at when the document was raised.
QuantityBatch quantity on the document.
ReferenceRelated document, for example the job order of a Job Work DC Out or the DC Out of a DC In.
StatusStatus of the document, where it has one.

5. Export or Print Report​

  • Excel β†’ Downloads the result with three sheets: Batch Creation, Process Wise Utilization and Utilization Transactions, covering every batch listed. Adjusted inspections are marked (Adjusted) beside the inspection number.
  • Print β†’ Prints the report.
note

That’s it! You’ve learned how to use the Batch Utilization Report in the DMeX application. For further assistance, please contact the Customer Support Team.